USE [Production2]
GO

/****** Object:  View [dbo].[V_CAL_Part_Test_Series_Enable]    Script Date: 10/28/2014 21:55:48 ******/
IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[V_CAL_Part_Test_Series_Enable]'))
DROP VIEW [dbo].[V_CAL_Part_Test_Series_Enable]
GO

USE [Production2]
GO

/****** Object:  View [dbo].[V_CAL_Part_Test_Series_Enable]    Script Date: 10/28/2014 21:55:48 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO





CREATE VIEW [dbo].[V_CAL_Part_Test_Series_Enable]  
AS  
SELECT     distinct s.test_series_id, s.test_series_description, s.test_series_obsolete_flag, s.test_series_obsolete_date, s.line_id, s.part_id, s.part_category, p.part_platform  
FROM         dbo.CAL_Part_Test_Series AS s LEFT OUTER JOIN  
                      dbo.PROD_Part AS p ON s.part_id = p.part_id
                      inner join V_CAL_Part_Functional_Test As f
                      on s.test_series_id = f.test_series_id



GO


